package com.bs.dao;

import java.util.List;

import org.springframework.dao.DataAccessException;

import com.bs.bean.Item;

public interface ItemDAO {
	public int delete(Item item);

	public int batchDelete(String ids);
	
	public List<Item> findAll(int start, int limit);

	public List<Item> findAll(String start, String end, String type);

	public List<Item> findAll();

	public void save(Item item) throws DataAccessException;

	public int update(Item item, String type);

	public int totalCount();

	public List<Item> sumBySeason(String start, String end, String type);

	public List<Item> supportBonusBySeason(String start, String end, String type);
	
	public List<Item> managerBonusBySeason(String start, String end, String type);
	
	public List<Item> teamBonusBySeason(String start, String end, String type);

	public List<Item> busiBonusBySeason(String start, String end, String type); 
	
	public List<Item> query(Item item);
	
	public Item sumByPerson(String start, String end, String type, int personId);
	
	public Item sumBySupportType(String start, String end, String type, String supportType);
	
	public Item sumByManager(String start, String end, String type, int personId);
}
